MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | amon | | cm | | hive | | hue | | mysql | | oozie | | performance_schema | | test | +--------------------+ 9 rows in set (0.01 sec)
MariaDB [(none)]> show variables like '%max_connect_errors%'; +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | max_connect_errors | 10 | +--------------------+-------+ 1 row in set (0.00 sec)
MariaDB [(none)]> set global max_connect_errors = 1000; Query OK, 0 rows affected (0.02 sec)
MariaDB [(none)]> show variables like '%max_connect_errors%'; +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | max_connect_errors | 1000 | +--------------------+-------+ 1 row in set (0.00 sec)